select * from products where pro_name like '%Train%dresses%' or pro_des like '%Train%dresses%'union all select * from products where (pro_name like '%Train%' or pro_des like '%Train%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%Train%dresses%' or pro_des not like '%Train%dresses%')

Baby Blue and White Strapless Dress for Quince with Embroidery

Long Sleeves Appliqued Red Quinceanera Dress with Black Hem

Popular Ball Gown Light Purple Ruffled Beaded Sweet 16 Dresses

Two-toned Sweetheart Ruffled Beaded Sweet Sixteen Dresses

Plus Size Baby Blue and White Appliqued Quinceanera Dresses

Aquamarine One Shoulder Beaded Appliqued Dress for Quince

Modernist Leopard Print Multi-colored Dresses for Sweet 15

Two-toned Quinceanera Party Dress with Appliques and Pick Ups

Sweetheart Beaded Multi-color Quinceanera Gown with Pick Ups

Special Ruffled Beaded Multi-color Tiered Dresses for Sweet 15

Green Sweetheart Beaded Sweet 16 Dress with Rolling Flowers

Purple Beaded Brush Train Quinceneara Dresses with Rolling Flowers

Blue Beaded Brush Train Sweet 15 Dresses with Rolling Flowers

Purple Floor-length Taffeta Quinceanera Dresses with Pick-ups

Snow White Multi-color Beaded Sweetheart Quinceneara Dresses with Ruffles

Noble Strapless Burgundy Sweet Sixteen Dresses with Pick-ups

Beaded Sweetheart Tiered Ruffles Organza Sweet Sixteen Dresses

Sweetheart Aqua Blue Layered Taffeta and Organza Quince dresses

Colorful Printing and Ruffled Organza Quinceanera Dresses

Multi-color Strapless Quinceanera Dresses with Tiered Ruffles

Chapel Train Taffeta and Organza Quinceanera Dresses with Appliques

Sweep Train Turquoise Embroidery Quinceanera Gown Dresses

Burgundy Sweep Train Quinceanera Dresses with Embroidery

Mint Sweetheart Organza Beading Quinceanera Dresses with Appliques

Royal Blue Embroidery Appliqued Quinceanera Dresses with Pick-ups

Hunter Halter Top Beading Appliqued Quinceanera Dresses with Pick-ups

Classic Purple Strapless Dresses for a Quince with Appliques

Royal Blue Lace up Back Dresses for a Quince with Capelet and Pick-ups

Flower Accent Waist Baby Pink Multi-Layered Dresses for a Quince

Colorful Zebra Print Appliques Vestidos De Quinceanera with Ruffles